<?php
session_start();

//if(!$currentUser) header("Location: login.html");
function getParam($Username){
    $value = isset($_GET[$Username])?trim($_GET[$Username]):"";
    $value = str_replace("'","''",$value);
    return $value;

}
$currentUser = $_SESSION["user"];
$pageIndex = isset($_GET["pageIndex"])?trim($_GET["pageIndex"]):1;
if($pageIndex<1) $pageIndex=1;
$pageSize = isset($_GET["pageSize"])?trim($_GET["pageSize"]):5;
if($pageSize<1) $pageSize=5;

$where = "";
$queryTitle = getParam("Title");
//$queryTitle = isset($_GET["Title"])?trim($_GET["Title"]):"";
if($queryTitle){
    if($where) $where .=" AND ";
    $where .= " `Title` LIKE ('%$queryTitle%')";
}
$queryAuthor = getParam("Author");
if($queryAuthor){
    if($where) $where .=" AND ";
    $where .= " `AuthorName` LIKE ('%$queryAuthor%')";
}
$queryMinDate = getParam("minDate");
if($queryMinDate){
    if($where) $where .=" AND ";
    $where .= " `UpdateTime`>=$queryMinDate";
}

$queryMaxDate = getParam("maxDate");
if($queryMaxDate){
    if($where) $where .=" AND ";
    $where .= " `UpdateTime`<=$queryMaxDate";
}

if($where) $where = " WHERE " .$where;
$sqlTotal = "select count(*) as T  from  `article` $where";
$conn = new mysqli("localhost","root","","myblog");
//$rs = $conn->query($queryTotal);
$rs = $conn->query($sqlTotal);
if($conn->error) die($conn->error);
$total = $rs->fetch_assoc()["T"];

$queryTitle ="";
$queryAuthor = "";

$queryMaxDate = "";

$pageCount = ceil($total/$pageSize);
if($pageIndex>$pageCount) $pageIndex = $pageCount;
if($pageIndex<1) $pageIndex = 1; 

$startRowNo = $pageSize*($pageIndex-1);

$rows = [];
$rowsql = "select * from `article` $where limit $startRowNo,$pageSize";
$rs = $conn->query($rowsql);
if($conn->error) die($conn->error);
while($row = $rs->fetch_assoc()){
    $rows[] = $row;
}{
function makePageUrl($pageIndex){
    $querystring = " pageIndex=$pageIndex";
    foreach($_GET as $k=>$v){
        if($k==="pageIndex") continue;
        $querystring .= "&$k=$v";

    }
    return $querystring;
}
/*function makePageUrl1($i){
    $querString = $_SERVER["QUERY_STRING"];
    if(preg_match('/pageIndex=\d+/',$querString)){
        $querString = preg_replace('/pageIndex=\d+/','pageIndex='.$i,$querString);
    }else {
        $querString .= "&pageIndex=$i";
    }
    return $querString;*/
}


?>


<!DOCTYPE html>
<html>
        <head>
            <meta http-equiv="content-type" content="text/html;charset=utf8"/>
            <title>第一个网页</title>
        </head>
        <body>
            <style type="text/css">
        *{
            font-size: 14px;
            padding: 0;
            margin: 0;
        }
        table{
            border-collapse: collapse;
            background-color: #eee;
            border: 1px solid #666;
            width: 100%;
        }
        table td,table th{
            padding: 6;
            border-collapse: collapse;
            border: 1px solid #ccc;

        }
        table th{
            background-color: #333;
            color: #eee;
        }
        table th div.title{
            width: 40px;
        }
        .filter{
            color: blue;
            margin: 10px 0px;
        }

        </style>
            <h3>文章列表</h3>
            <a href="article_add.php">新建文章</a>
            <input type="text"   name="Title" id="keyword" value="" />
            <script type="text/javascript">
            document.getElementById("keyword").onblur = function(){
                var key = document.getElementById("keyword").value;
            }
            function searchkey(key,node){
                if(!node)node = document.body;
                for(let i=0,j=node.childNodes.length;i<j;i++){
                    let child = node.childNodes[i];
                    let val = child.nodeValue;
                    if(!val){
                        if(child.childNodes && child.childNodes.length){
                            searchkey(key, child);
                        }else continue;
                    }else {
                        var hasKey = val.indezOf(key)>=0;
                        if(hasKey) node.style.border = "1px solid red";
                    }

                }
            }
            </script>

            <form action="" class="filter" method="GET">
            <span>
                    <label>标题</label>
                    <input type="text" name="Title" id="Title" value="<?=$queryTitle?>" />

            </span>
                <span>
                    <label>作者</label>
                    <input type="text" name="Author" id="Title" value="<?=$queryAuthor?>" />

                </span>
               <span>
                    <label>时间</label>
                    <input type="text" name="minDate" value="<?=$queryMinDate?>"  />
                    -  <input type="text" name="maxDate" value="<?=$queryMaxDate?>"  />

               </span>
                <input type="submit" name="submit" value="搜索"/>
            </form>
            <script type="text/javascript">
            function jumpTo(pageIndex){
                var url = "?";
                var form = document.getElementById("form");
                var data = getData(form,{});
                for(var n in data){
                    url +="&"+ n + "=" + data[n];
                }
                url += "&pageIndex=" + pageIndex;
                location.href = url;
            }
            function getDate(form,data){
                for(let i=0,j=form.childNodes.length;i<j;i++){
                    let child = form.childNodes[i];
                    if(child.tagName=="INPUT") data[child.name] = child.value;
                    if(child.childNodes && child.childNodes.length) getDate(child,data);

                }
                return data;
            }
        </script>
            <table border="1">
                <thead>
                    <tr>
                        <th><div class="title">标题</div></th>
                        <th>作者</th>
                        <th>时间</th>
                        <th>操作</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach($rows as $row){?>
                    
                <tr>
                    <td>
                        <?=$row["Title"]?> 
                    </td>
                    <td>
                        <?=$row["AuthorName"]?>
                    </td>
                    <td>
                        <?=$row["UpdateTime"]?><br/>
                        <?=$row["CreateTime"]?>
                    </td>
                    <td>
                        详细
                        <?php if ($currentUser["Id"] == $row["AuthorId"]) {?>
                        删除
                        <?php }?>
                    </td>
                </tr>
                <?php }?>
                </tbody>
                <tfoot>
                    <tr>
                        <td colspan="4">
                            共<?=$total ?>条记录，共<?=$pageCount?>页当前为<input type='text' value="2"
                            value="<?=$pageIndex?>" onblur="jumpTo(this.value)"/>页,
                            <a href="art_list.php?<?=makePageUrl(1)?>">首页</a><
                            <?php for($i = 1;$i<=$pageCount;$i++) {?>
                                <a href="art_list.php?<?=makePageUrl($i)?>"><?=$i ?></a>
                            <?php } ?>
                            >
                            <a href="art_list.php?<?=makePageUrl($pageCount)?>">尾页</a>
                        </td>
                    </tr>
            
                </tfoot>
            </table>
        </body>
</html>